IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[SrvrInstncMemoryCfgMSSQL]') AND type in (N'U'))
BEGIN
     DROP TABLE [dbo].[SrvrInstncMemoryCfgMSSQL]
END
GO

SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[SrvrInstncMemoryCfgMSSQL](
     [SrvrInstncId] [int]          NOT NULL,
     [MemoryShare]  [decimal](5,1) NOT NULL,
     [LastModDt]    [datetime]     NOT NULL CONSTRAINT [DF_SrvrInstncMemoryCfgMSSQL_LastModDt] DEFAULT (getdate()),
     CONSTRAINT [PK_SrvrInstncMemoryCfgMSSQL] PRIMARY KEY CLUSTERED ( [SrvrInstncId] ASC )
) ON [PRIMARY]
GO

SET ANSI_PADDING OFF
GO
